CREATE FUNCTION dbo.GetParentName(@acc_code VARCHAR(20))
RETURNS VARCHAR(90)
AS
BEGIN
    DECLARE @parent_code VARCHAR(20)
    DECLARE @parent_name VARCHAR(90)
    
    SET @parent_code = dbo.GetParent(@acc_code)
    
    SELECT @parent_name = acc_name 
    FROM Account 
    WHERE acc_code = @parent_code
    
    RETURN @parent_name
END